31 | TypedQuery implementation problems, at.debitSign, at.creditSign, at.reportTypeId)" + " from Account acct" + " left outer join AccountTransaction att on acct.id = att.accountId" + " left outer join Transaction trans on att.transactionId = trans.id" + " left outer join AccountGroup ag on acct.accountGroupId = ag.id |
30 | Query execution time issue Entity e inner join e.person person inner join person.address address left join address.place addressPlace left join address.city addressCity left join address.county addressCounty left join person.birthPlace birthPlace left join person.birthCounty birthCounty left join person |
21 | How to convert a boolean to an int in the query? DISTINCT m FROM Person m LEFT OUTER JOIN m.answers answers LEFT OUTER JOIN answers.persons |
21 | @OneToOne query issue with OR and IS NULL that has another passes the FROM clause, which precedes the WHERE clause. Try LEFT OUTER JOIN: SELECT a FROM A a LEFT JOIN a.another b WHERE a.another IS NULL OR b.counter = 0 support Support Thank you very much... that works as expected! paddy Patrick Gerhardt ... another.counter = 0 is a short form of the this equivalent query: SELECT a FROM A a JOIN a.another b |
7 | javax.persistence.criteria.Root> fetch(String attributeName) Create a fetch join to the specified attribute using an inner join. Create a fetch join to the specified attribute using an inner join. Parameters: attributeName - name of the attribute for the target of the join Returns: the resulting fetch join Throws |
7 | Database Explorer automatically. Tabbed Windows Three tabbed windows are displayed on the left side of the Explorer ... viewer to focus on the selected object. Executing Queries The [Query] window on the left side enables ... of different Explorer components. Select one or more elements on the left side and then use |
5 | Paths and Types in JPQL and Criteria API. It might be easier to understand exactly how this works by considering the equivalent JOIN query. Entity ... are represented in the JPA Criteria API by the Path interface and by its subinterfaces (From, Root, Join and Join's descendants). Path Expressions The Root and Join interfaces (which are subinterfaces |
5 | Issue with UPPER ? COUNT($1) FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.mitgliedschaft $2 LEFT JOIN $1.profile $3 LEFT JOIN $3.organisation $4 LEFT JOIN $1.postalAddresses $5 LEFT JOIN $1 ... .Mitglied $1 LEFT JOIN $1.mitgliedschaft $2 LEFT JOIN $1.profile $3 LEFT JOIN $3.organisation $4 LEFT |
5 | [ObjectDB 2.5.5_03] Unexpected exception (Error 990) LEFT OUTER JOIN t.lastGeocodedPosition l WHERE l.receiveTime < :last See also this paragraph in ... work but I modified it a little bit and now it does: SELECT t FROM Unit t LEFT OUTER JOIN t ... have NPE, because OR is evaluated from left to right. I am not sure if this should be the case |
0 | javax.jdo.Query variableDeclaration - the name of the variable in the outer query to bind the results of the subquery ... terms of the outer query Since: JDO 2.1 See Also: addSubquery(Query sub, String variableDeclaration ... of the expression in the outer query. If the trimmed expression is the empty String |
